PhysicalLocationTaxRegionAssociation

Entity Definition

Logical Name : PhysicalLocationTaxRegionAssociation
Physical Name : LO_LCN_PHY_TX_RGN

An association denoting which TaxRegions a particular PhysicalLocation falls into over time.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TaxRegionID (FK)(PK) A unique identifier for a Tax Region. ID_RGN_TX Identity integer TaxRegion(CO_RGN_TX)
EffectiveDateTime (PK) The date and time a physical location is associated with a tax region. TS_EF EffectiveDateTime datetime
GeographicLocationID (FK)(PK) Token ID for a GeographicLocation ID_GEO_LCN Identity integer GeophysicalLocation(CO_GEO_LCN)
ExpirationDateTime The date and time a physical location is no longer associated with a tax region. TS_TP ExpirationDateTime datetime

Relationships

Parent Entity Verb Phrase Child Entity
GeophysicalLocation defines location for PhysicalLocationTaxRegionAssociation
TaxRegion is part of PhysicalLocationTaxRegionAssociation

Logical Views containing PhysicalLocationTaxRegionAssociation

Logical View
Logical 05000 - Taxation - Macro View
Logical 05100 - Taxation - Rules View
Logical 05200 - Taxation - Retail Transaction View